package com.group3.hospital.mapper;/*
 *@author 时崎
 * 2022/01/03
 */

import com.group3.hospital.bean.Subject;

import java.util.List;

public interface SubjectMapper {
    //显示非手术科室
    List<Subject> showNoOpe() throws Exception;
    //显示手术科室
    List<Subject> showOpe() throws Exception;
    //显示诊断相关科室
    List<Subject> showDiagnosis() throws Exception;
    //根据具体科室名称查询科室信息
    Subject queryByName(String subjectName)throws Exception;
    //根据id删除科室
    void deleteById(Integer subjectId)throws Exception;

    void update(Subject sub) throws Exception;
}
